# Codebook for South Carolina Audit Data



## Description

Elections in South Carolina are audited through an open process, in which all of the files used to audit are released publicly. The raw files can be found [here](https://www.scvotes.org/data/AuditDesc.html). These are the same files found at the link, just formatted for easier usage by academics. MEDSL has cleaned two of the types of files for public usage. They are as follows:

## EL 155:
	El 155 contains a copy of each ballot cast on a voting machine. It lists the precinct and machine number associated with each ballot but does not indicate the time the ballot was cast or the voter casting the ballot. Furthermore, these logs are shuffled, which makes matching back to voters impossible. 

## EL 152:
	EL 152 is a list of each event that occurred on every voting machine. It contains the machine number, the PEB that was used to trigger the event, the date and time the event occurred but not the precinct in which the machine was used.

## Notes:
	There is a known challenge in using machine numbers to try to match precinct back to `EL 152`. Due to split precincts, one voting machine may be used in multiple precincts. 




## File naming convention for `EL 155`
- All  `EL 155` files are named in the following format: `Election` `County` `Ballot_Images.csv`.

## Variables in `EL 155`
The variables are listed as they appear in the data file

### Votronic
- **Description**: The ID of the Votronic voting machine

------------------

### Ballot Index
- **Description**: The ballot style for the county

-----------------

### Candidate
- **Description**: The candidate the vote was cast for

----------------

### Initial Vote
 - **Description**: Whether or not this was the first vote cast by the voter

----------------

### Precinct
 - **Description**: The precinct the vote was cast in

 ---------------
 
### County
 - **Description**: The county that the vote was cast in

-----------------

### Voter No.
 - **Description**: An index of how many voters used that machine during the election. **NOT IN CHRONOLOGICAL ORDER.**

-----------------

### Straight Ticket
 - **Description**: Whether or not the voter cast their ballot for the straight ticket option. Not applicable in primaries.

-----------------




## File naming convention for `EL 155`
- All  `EL 155` files are named in the following format: `Election` `County` `Ballot_Images.csv`.

## Variables in `EL 155`
The variables are listed as they appear in the data file

### Votronic
- **Description**: The ID of the Votronic voting machine

------------------

### Ballot Index
- **Description**: The ballot style for the county

-----------------

### Candidate
- **Description**: The candidate the vote was cast for

----------------

### Initial Vote
 - **Description**: Whether or not this was the first vote cast by the voter

----------------

### Precinct
 - **Description**: The precinct the vote was cast in

 ---------------
 
### County
 - **Description**: The county that the vote was cast in

-----------------

### Voter No.
 - **Description**: An index of how many voters used that machine during the election. **NOT IN CHRONOLOGICAL ORDER.**

-----------------

### Straight Ticket
 - **Description**: Whether or not the voter cast their ballot for the straight ticket option. Not applicable in primaries.

-----------------



## File naming convention for `EL 152`
`County`  `Election` `Audit Files_EL_152_Clean.csv`.

## Variables in `EL 155`
The variables are listed as they appear in the data file


### Votronic
- **Description**: The ID of the Votronic voting machine. Should generally not be used to join to `EL 155`, since one voting machines may be used in two precincts in cases of split precincts. 

------------------

### PEB
- **Description**: The ID of the Personal Electronic Ballot used to initiate the action

-----------------

### Type
- **Description**: The type of action that occurred

----------------

### Date
- **Description**: The date the action occurred

----------------


### Time
- **Description**: The time the action occurred (EST)

----------------


### Event
- **Description**: The code for the action that occurred

----------------

#### Last Updated 2/19/2019

